package com.cn.mobileproject.db.table;

public class OrgTable {
	public static final String TABLE_NAME = "t_org";
	public static final String FIELD_ID="id";
	public static final String FIELD_NAME="orgname";
	public static final String FIELD_CODE="code";
	public static final String FIELD_PARENTID="parentid";
	public static final String FIELD_TREECODE="treeCode";
	public static final String FIELD_LEAF="leaf";
	
	

	
	public static final String[] TABLE_COLUMNS = new String[] { 
		 FIELD_ID,
		 FIELD_NAME,
		 FIELD_CODE,
		 FIELD_PARENTID,
		 FIELD_TREECODE,
		 FIELD_LEAF
	};

	public static final String CREATE_TABLE = "create table "
        + TABLE_NAME + " (" 
        + FIELD_ID + " text primary key , "
        	+ FIELD_NAME + " text ,"
        	+ FIELD_CODE + " text ,"
        	+ FIELD_PARENTID + " text ,"
        	+ FIELD_TREECODE + " text ,"
        	+ FIELD_LEAF + " text "
	    	+ ")";
}
